package com.sto.stoapp.db.constant;


/**
 * 到包预报表Constant
 * @author mgf
 *
 */
public interface StoCastSonstant extends StoBaseConstant {
    /**
     * 航班号
     */
    public static final String CAST_FLIGHT = "flight";
    /**
     * 路由号
     */
    public static final String CAST_ROUTE_CODE = "route_code";
    /**
     * 单号/包号
     */
    public static final String  CAST_BAR_CODE = "bar_code";
    /**
     * 扫描网点
     */
    public static final String CAST_SCAN_SITE = "scan_site";
    /**
     * 扫描员
     */
    public static final String CAST_SCAN_MAN = "scan_man";
    /**
     * 备注
     */
    public static final String CAST_REMARK = "remark";
    /**
     * 扫描时间
     */
    public static final String CAST_SCAN_TIME = "scan_time";
    /**
     * 扫描日期
     */
    public static final String CAST_SCAN_DATE = "scan_date";
    /**
     * 增量时间
     */
    public static final String CAST_INC_TIME = "inc_time";
    /**
     * file文件名
     */
    public static final String CAST_FILE_NAME = "file_name";
    
    /**
     * 到包预报表
     */
    public static final String TAB_FORE_CAST = "tab_fore_cast";
    
    /**
     * 创建到包预报表
     */
    public static final String CREATE_FORE_CAST_TABLE = "CREATE TABLE "
            + " if not exists "
            + TAB_FORE_CAST
            + "("
            + "id  INTEGER PRIMARY KEY AUTOINCREMENT"
            + ","
            + CAST_BAR_CODE
            + " char(20)"
            + ","
            + CAST_FLIGHT
            + " char(8)"
            + ","
            + CAST_ROUTE_CODE
            + " char(20)"
            + ","
            + CAST_SCAN_SITE
            + " char(30)"
            + ","
            + CAST_SCAN_MAN
            + " char(20)"
            + ","
            + CAST_REMARK
            + " char(14)"
            + ","
            + CAST_SCAN_TIME
            + " char(20)"
            + ","
            + CAST_SCAN_DATE
            + " char(20)"
            + ","
            + CAST_INC_TIME
            + " char(14)"
            + ","
            + CAST_FILE_NAME
            + " char(40)"
            + ","
            + BACKUPS_ONE
            + " char(50)"
            + ","
            + BACKUPS_TWO
            + " char(50)"
            + ","
            + BACKUPS_THREE + " char(50)" + ")";
    
    /**
     * 删除到包预报表
     */
    public static final String DROP_CAST_TABLE = "drop table if exists "
            + TAB_FORE_CAST;
}
